SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS ON
GO
CREATE PROCEDURE [dbo].[AccountInfoInsert]
    @Id UNIQUEIDENTIFIER ,
    @ServiceInfoId UNIQUEIDENTIFIER ,
    @Login VARBINARY(MAX) ,
    @Password VARBINARY(MAX) ,
    @Email VARBINARY(MAX) ,
    @FirstName VARBINARY(MAX) ,
    @LastName VARBINARY(MAX) ,
    @SecretQuestion VARBINARY(MAX) ,
    @SecretAnswer VARBINARY(MAX) ,
    @MobilePhone VARBINARY(MAX) ,
    @ShortId VARBINARY(MAX) ,
    @AdditionalInfo VARBINARY(MAX)
AS 
    BEGIN 
        INSERT  INTO AccountInfo
                ( Id ,
                  ServiceInfoId ,
                  LOGIN ,
                  PASSWORD ,
                  Email ,
                  FirstName ,
                  LastName ,
                  SecretQuestion ,
                  SecretAnswer ,
                  MobilePhone ,
                  ShortId ,
                  AdditionalInfo ,
                  DateCreated ,
                  Deleted
                )
        VALUES  ( @Id ,
                  @ServiceInfoId ,
                  @LOGIN ,
                  @PASSWORD ,
                  @Email ,
                  @FirstName ,
                  @LastName ,
                  @SecretQuestion ,
                  @SecretAnswer ,
                  @MobilePhone ,
                  @ShortId ,
                  @AdditionalInfo ,
                  GETDATE() ,
                  0
                )
    END
GO
